<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddAppExtToAppTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('app', function (Blueprint $table) {
            //补充信息
            $table->integer('uet')->comment('用户量预估')->nullable();
            $table->tinyInteger('type')->comment('类型:核心应用、重要应用、一般应用')->nullable();
            $table->tinyInteger('is_foreign')->comment('是否对外:只对内、只对外、内外都有')->nullable();
            $table->integer('etv')->comment('预估价值')->nullable();
            $table->string('address')->comment('域名/IP地址')->nullable();
            $table->string('ops')->comment('开放端口和服务')->nullable();
            $table->string('msv')->comment('中间件和服务及版本信息')->nullable();
            $table->string('lvv')->comment('开发语言和使用第三方库及版本信息')->nullable();
            $table->string('ut')->comment('测试账号')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('app', function (Blueprint $table) {
            $table->dropColumn(['uet','type','is_foreign','etv','address','ops','msv','lvv','ut']);
        });
    }
}
